IF OBJECT_ID('dbo.GetActivityTypes') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.GetActivityTypes
    IF OBJECT_ID('dbo.GetActivityTypes') IS NOT NULL
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.GetActivityTypes >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.GetActivityTypes >>>'
END
go
-- =======================================================================
-- Procedure Name: dbo.GetActivityTypes
--
-- Author:      Kevin Cashman, Parallax Consulting LLC
--
-- Create date: 9/11/2007
--
-- Description: Returns list of ActivityTypes
--
-- Parameters:  NONE
--              
-- Returns:     INT, 0=Success, -1=Error
--
-- SampleCall:
-- EXECUTE dbo.GetActivityTypes 
--
--------------------------------------------------------------------------
-- Date        Initials  Modification
--------------------------------------------------------------------------
-- 9/11/07     KC        Created
--
-- =======================================================================
CREATE PROCEDURE dbo.GetActivityTypes
AS
BEGIN
     SET NOCOUNT ON 

     SELECT    DISTINCT ActivityCode, ActivityDescription
     FROM      dbo.AgrAgreement_Info
     WHERE     ActivityCode IS NOT NULL
     ORDER BY ActivityDescription
     
END

GO
IF OBJECT_ID('dbo.GetActivityTypes') IS NOT NULL
    PRINT '<<< CREATED PROCEDURE dbo.GetActivityTypes >>>'
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.GetActivityTypes >>>'
go


GRANT EXECUTE ON dbo.GetActivityTypes TO InsightReport,Insight
go